<html>
<head>
<title> Managing Database Servers </title>
<meta name="Keywords" content="" />
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link rel="stylesheet" type="text/css" href="stylesheet.css"/>
<script src="locate.js"></script>
<link href="prettify.css" type="text/css" rel="stylesheet" />
<script type="text/javascript" src="prettify.js"></script>
</head>
<script src="highlight.js"></script>
<body bgcolor="#FFFFFF" text="#000000" link="#0000A0" alink="#008000" vlink="#FF0000" onLoad="FindCorrectTOCPage(); prettyPrint()">
<table cellpadding="0" cellspacing="0" border="0">
<tr valign="top">
<td>
<p class="pagenavigation"><a href="17191.htm" target="_self"><img src="38976.gif" alt="Previous page" height="16" width="16" vspace="0" hspace="1" align="top" border="0"> Previous page</a></p></td>
<td>
<p class="pagenavigation"><a href="21445.htm" target="_self"><img src="38977.gif" alt="Next page" height="16" width="16" vspace="0" hspace="1" align="top" border="0"> Next page</a></p></td>
<td>
<p class="pagenavigation"><a href="toc4151869.htm" target="TOC"><img src="38970.gif" alt="Locate page" height="16" width="16" vspace="0" hspace="1" align="top" border="0"> Locate page</a></p></td>
<td>
<p class="pagenavigation"><a href="toc4151869.htm" target="TOC"><a class="" title="" href="javascript:print();" target="_self"><img src="39072.gif" alt="Print this page" height="16" width="16" vspace="0" hspace="1" align="top" border="0"></a></a></p></td>
</tr>
</table>
<h3 class="heading3">Managing Database Servers</h3>
<p class="procedureheading">To manage a database server:</p>
<ol class="procedurelistnumber"><li class="procedurelistnumber">Click the <strong class="specialbold">Server</strong> shortcut in the navigation pane.</li><li class="procedurelistnumber">Click the <strong class="specialbold">Database Servers</strong> icon in the <strong class="specialbold">Services</strong> group.</li><li class="procedurelistnumber">Click the icon <img src="24314.gif" alt="db webadmin" height="16" width="16" vspace="0" hspace="0" align="bottom" border="0"> corresponding to the database server you need. A web interface of a database management tool will open in a separate browser window.</li></ol><p class="bodytext"></p>
<p class="procedureheading">To change the MySQL database server administrator's password:</p>
<ol class="procedurelistnumber"><li class="procedurelistnumber">Login to the MySQL database server as root.</li><li class="procedurelistnumber">Login to MySQL as root.</li><li class="procedurelistnumber">Issue the command at the prompt:<p class="preformattedbold"></p>
<p class="preformattedbold">mysql&gt; SET PASSWORD for ROOT = PASSWORD('new_password');</p>
<p class="preformattedbold"></p>
<p class="listcontinue">Where root is the user account, and new_password is the new administrator's password.</p>
</li><li class="procedurelistnumber">Log in to your Plesk control panel.</li><li class="procedurelistnumber">Click the <strong class="specialbold">Server</strong> shortcut in the navigation pane.</li><li class="procedurelistnumber">Click the <strong class="specialbold">Database Servers</strong> icon in the <strong class="specialbold">Services</strong> group.</li><li class="procedurelistnumber">Click the database server's name.</li><li class="procedurelistnumber">Type the new administrator's password and click <strong class="specialbold">OK</strong>.</li></ol><p class="bodytext"></p>
<p class="procedureheading">To change the PostgreSQL database server administrator's password:</p>
<ol class="procedurelistnumber"><li class="procedurelistnumber">Login to the PostgreSQL database server as root.</li><li class="procedurelistnumber">Login to PostgreSQL as root.</li><li class="procedurelistnumber">Issue the command at the prompt:<p class="preformattedbold"></p>
<p class="preformattedbold">ALTER USER root WITH PASSWORD 'new_password';</p>
<p class="preformattedbold"></p>
</li><li class="procedurelistnumber">Log in to your Plesk control panel.</li><li class="procedurelistnumber">Click the <strong class="specialbold">Server</strong> shortcut in the navigation pane.</li><li class="procedurelistnumber">Click the <strong class="specialbold">Database Servers</strong> icon in the <strong class="specialbold">Services</strong> group.</li><li class="procedurelistnumber">Click the database server's name.</li><li class="procedurelistnumber">Type the new administrator's password and click <strong class="specialbold">OK</strong>.</li></ol><p class="bodytext"></p>
<p class="procedureheading">To unregister a database server from Plesk:</p>
<ol class="procedurelistnumber"><li class="procedurelistnumber">Click the <strong class="specialbold">Server</strong> shortcut in the navigation pane.</li><li class="procedurelistnumber">Click the <strong class="specialbold">Database Servers</strong> icon in the <strong class="specialbold">Services</strong> group.</li><li class="procedurelistnumber">Select the check box to the right of the database server's name.</li><li class="procedurelistnumber">Click <img src="17726.gif" alt="" height="16" width="16" vspace="0" hspace="0" align="bottom" border="0"> <strong class="specialbold">Remove Selected</strong>.</li><li class="procedurelistnumber">Confirm the operation and click <strong class="specialbold">OK</strong>.</li></ol><p class="bodytext"></p>
<p class="procedureheading">To unregister from Plesk a database server that has databases or is assigned as default for hosting customers' databases:</p>
<ol class="procedurelistnumber"><li class="procedurelistnumber">Delete databases from the database server:<ol class="procedurelistnumber2"><li class="procedurelistnumber2">Click the <strong class="specialbold">Server</strong> shortcut in the navigation pane.</li><li class="procedurelistnumber2">Click the <strong class="specialbold">Database Servers</strong> icon in the <strong class="specialbold">Services</strong> group.</li><li class="procedurelistnumber2">Click the host name of a database server that you wish to unregister from Plesk.</li><li class="procedurelistnumber2">Click the <strong class="specialbold">Databases</strong> tab.</li><li class="procedurelistnumber2">Select the checkbox in the upper-right corner of the list to select all databases.</li><li class="procedurelistnumber2">Click <img src="17726.gif" alt="" height="16" width="16" vspace="0" hspace="0" align="bottom" border="0"> <strong class="specialbold">Remove Selected</strong>.</li><li class="procedurelistnumber2">Confirm removal and click <strong class="specialbold">OK</strong>.</li></ol></li><li class="procedurelistnumber">Make another database server default:<ol class="procedurelistnumber2"><li class="procedurelistnumber2">Click the <strong class="specialbold">Database servers</strong> shortcut in the path bar at the top of the screen.</li><li class="procedurelistnumber2">Click the host name of a database server that you wish to make default. This should be the same database server type (MySQL or PostgreSQL) as the one you are going to delete.</li><li class="procedurelistnumber2">Select the check box labeled <strong class="specialbold">Use this server as default for MySQL</strong>. If you have a PostgreSQL database server, select the check box labeled <strong class="specialbold">Use this server as default for PostgreSQL</strong>.</li><li class="procedurelistnumber2">Click <strong class="specialbold">OK</strong>.</li></ol></li><li class="procedurelistnumber">Return to the list of database servers (<strong class="specialbold">Server </strong>&gt;<strong class="specialbold"> Database Servers</strong>).</li><li class="procedurelistnumber">Select a check box corresponding to the database server that you no longer need.</li><li class="procedurelistnumber">Click <img src="17726.gif" alt="" height="16" width="16" vspace="0" hspace="0" align="bottom" border="0"> <strong class="specialbold">Remove Selected</strong>.</li><li class="procedurelistnumber">Confirm the operation and click <strong class="specialbold">OK</strong>.</li></ol><p class="note"><strong class="buttons">Important:</strong> You cannot remove site applications' databases this way. To remove them, you should uninstall the respective site applications from the domains that use them.</p>
<p class="bodytext">For instructions on managing databases, refer to the <a id="h17745" class="jumptemplate" title="Deploying Databases" href="17301.htm" target="_self">Deploying Databases</a> section of this guide.</p>


</body>
<script>highlightTOC()</script>
</html>

